/*
 * Filename : SOCErrorConstants.java 
 * Package : com.spi.soconversion
 * Created by: Software Paradigms International Group, LLC. (SPI) 
 * Copyright (c) 2010 HBC
 */
package com.spi.soconversion.util;

/**
 * This class Contains look up for Error Messages in Sales Order Conversion Application.
 * Look Up scheme for Error messages is as follows :
 * 1001-1099 Missing Values
 * 2001-2099 Failed Operations
 * 3001-3099 Invalid Values
 * <p>
 * Issues: <p>
 * <ul>
 * </ul>
 * History: <p>
 * <ul>
 * <li>2010.04.17 pk: created
 * </ul>
 *
 * @author Priya Khanna, SPI (pk)
 */

public class ErrorConstants {

	/**
     * Constant to indicate when xml file already exists and delete permission is not available 
	 */
	public static final int FAILED_FILE_DELETE = 2001;
	
	/**
	  * Constant to indicate when unable to create file
	  */
	public static final int FAILED_FILE_CREATE = 2002;
	
	/**
	  * Constant to indicate when unable to close file
	  */
	public static final int FAILED_FILE_CLOSE = 2003;
	
	/**
	  * Constant to indicate when unable to write file
	  */
	public static final int FAILED_FILE_WRITE = 2004;
	
	/**
	  * Constant to indicate when unable to connect to database
	  */
	public static final int FAILED_DATABASE_CONNECTION = 2005;
	
	/**
	  * Constant to indicate when unable to populate FLATTABLE_CLOSED_SALES_ORDER
	  */
	public static final int FAILED_DATA_POPULATION_FLATTABLE_CLOSED_SALES_ORDER = 2006;
	
	/**
	  * Constant to indicate when No records populated to FLATTABLE_CLOSED_SALES_ORDER
	  */
	public static final int NO_RECORD_POPULATION_FLATTABLE_CLOSED_SALES_ORDER = 2007;
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_INSTALL_BASE_INFO = 2008;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_INSTALL_BASE_INFO = 2009;
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_INSTALL_BASE_ADDR
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_INSTALL_BASE_ADDR = 2010;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_INSTALL_BASE_ADDR
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_INSTALL_BASE_ADDR = 2011;
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_INSTALL_BASE_CONT
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_INSTALL_BASE_CONT = 2012;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_INSTALL_BASE_CONT
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_INSTALL_BASE_CONT= 2013;
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_INSTALL_BASE_NOTES
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_INSTALL_BASE_NOTES = 2014;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_INSTALL_BASE_NOTES
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_INSTALL_BASE_NOTES = 2015;
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_INSTALL_BASE_WTY
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_INSTALL_BASE_WTY = 2016;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_INSTALL_BASE_WTY
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_INSTALL_BASE_WTY = 2017;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int FAILED_ANALYZE_TBL_STAGING_INSTALL_BASE_INFO = 2018;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_STAGING_INSTALL_BASE_ADDR
	  */
	public static final int FAILED_ANALYZE_TBL_STAGING_INSTALL_BASE_ADDR = 2019;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_STAGING_INSTALL_BASE_CONT
	  */
	public static final int FAILED_ANALYZE_TBL_STAGING_INSTALL_BASE_CONT = 2020;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int FAILED_ANALYZE_TBL_STAGING_INSTALL_BASE_NOTES = 2021;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_STAGING_INSTALL_BASE_WTY
	  */
	public static final int FAILED_ANALYZE_TBL_STAGING_INSTALL_BASE_WTY = 2022;
	
	/**
	  * Constant to indicate when unable to create sql statements for TBL_STAGING_INSTALL_BASE_INFO and TBL_STAGING_INSTALL_BASE_NOTES
	  */
	public static final int FAILED_DATA_PROCESS_INSTALL_BASE = 2023;
	
	/**
	  * Constant to indicate when unable to process particular record in TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int FAILED_RECORD_PROCESS_FLATTABLE_INSTALL_BASE = 2024;
	
	/**
	  * Constant to indicate when unable to process particular record in TBL_STAGING_INSTALL_BASE_NOTES
	  */
	public static final int FAILED_RECORD_PROCESS_FLATTABLE_INSTALL_BASE_NOTES = 2025;
	
	/**
	  * Constant to indicate when unable to close result set for TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int FAILED_CLOSE_RESULTSET_FLATTABLE_INSTALL_BASE = 2026;
	
	/**
	  * Constant to indicate when unable to close result set for TBL_STAGING_INSTALL_BASE_NOTES
	  */
	public static final int FAILED_CLOSE_RESULTSET_FLATTABLE_INSTALL_BASE_NOTES= 2027;
	
	/**
	  * Constant to indicate when unable to close statement object for TBL_STAGING_INSTALL_BASE_NOTES
	  */
	public static final int FAILED_CLOSE_STATEMENT_FLATTABLE_INSTALL_BASE_NOTES= 2028;
	
	/**
	  * Constant to indicate when unable to close statement object for TBL_STAGING_INSTALL_BASE_INFO
	  */
	public static final int FAILED_CLOSE_STATEMENT_FLATTABLE_INSTALL_BASE= 2029;
	
	/**
	  * Constant to indicate when exception occurs while closing connection to database
	  */
	public static final int FAILED_CLOSE_CONNECTION = 2030;
	
	/**
	  * Constant to indicate when xml validation failed with XSD
	  */
	public static final int FAILED_XML_VALIDATION_WITH_SAX_PARSER_EXCEPTION = 2031;
	
	/**
	  * Constant to indicate when schema not loaded from xsd
	  */
	public static final int FAILED_SCHEMA_LOAD_FROM_XSD = 2032;
	
	/**
	  * Constant to indicate when xml validation failed with I/O exception
	  */
	public static final int FAILED_XML_VALIDATION_WITH_IO_EXCEPTION = 2033;
	
	/**
	  * Constant to indicate when unable to move xml file to bad xml directory
	  */
	public static final int FAILED_FILE_MOVE_TO_BAD_XML_DIRECTORY= 2034;
	
	/**
	  * Constant to indicate when unable to move xml file to good xml directory
	  */
	public static final int FAILED_FILE_MOVE_TO_GOOD_XML_DIRECTORY= 2035;
		
	/**
	  * Constant to indicate when error occurred during fetching batch number from CONVERSION_BATCH_RECORDS
	  */
	public static final int FAILED_FETCH_BATCH_NUMBER= 2036;
	
	/**
	  * Constant to indicate when error occurred during fetching total records processed from CONVERSION_BATCH_RECORDS
	  */
	public static final int FAILED_FETCH_BATCH_INFO_FOR_TOTAL_RECORDS= 2037;
	
	/**
	  * Constant to indicate when error occurred during updating CONVERSION_BATCH_RECORDS
	  */
	public static final int FAILED_UPDATE_BATCH_INFO= 2038;
	
	/**
	  * Constant to indicate when No records populated to CONVERSION_BATCH_RECORDS
	  */
	public static final int NO_RECORD_POPULATION_CONVERSION_BATCH_RECORDS = 2039;
	
	/**
	  * Constant to indicate when oracle driver not found
	  */
	public static final int FAILED_ORACLE_DRIVER_SEARCH = 2040;	
	
	/**
	  * Constant to indicate when output directory doesn't exists
	  */
	public static final int INVALID_OUTPUT_DIRECTORY= 2041;
	
	/**
	  * Constant to indicate when number of input parameters are not correct
	  */
	public static final int INVALID_INPUT_PARAMETERS= 2042;
	
	/**
	  * Constant to indicate when input parameters are missing
	  */
	public static final int MISSING_INPUT_PARAMETERS= 2043;

	/**
	  * Constant to indicate when database user missing in input parameters
	  */
	public static final int MISSING_DATABASE_USER= 2044;
	
	/**
	  * Constant to indicate when when database password missing in input parameters
	  */
	public static final int MISSING_DATABASE_PASSWORD= 2045;
	
	/**
	  * Constant to indicate when when database host missing in input parameters
	  */
	public static final int MISSING_DATABASE_HOST= 2046;
	
	/**
	  * Constant to indicate when database service missing in input parameters
	  */
	public static final int MISSING_DATABASE_SERVICE= 2047;
	
	/**
	  * Constant to indicate when path for config file not passed to program
	  */
	public static final int MISSING_CONFIG_PROPERTY_FILE= 2048;
	
	/**
	  * Constant to indicate when invalid config file passed to program
	  */
	public static final int INVALID_CONFIG_PROPERTY_FILE= 2049;
	
	public static final int MISSING_ARGUMENT = 2100;
	
	/**
	  * Constant to indicate when xml directory missing in input parameters
	  */
	public static final int MISSING_XML_DIRECTORY= 2050;
	
	/**
	  * Constant to indicate when log directory missing in input parameters
	  */
	public static final int MISSING_LOG_DIRECTORY= 2051;

	/**
	  * Constant to indicate when batch size missing in input parameters
	  */
	public static final int MISSING_BATCH_SIZE= 2052;
	
	/**
	  * Constant to indicate when invalid value for flag fetchInstallBaseData passed
	  */
	public static final int INVALLID_VALUE_FOR_FETCHINSTALLBASEDATAONLY_FLAG= 2053;
	
	/**
	  * Constant to indicate when fetch install base data or not flag missing in input parameters
	  */
	public static final int MISSING_FETCH_INSTALLBASE_DATA_FLAG= 2054;
	
	/**
	  * Constant to indicate when batch size is not a valid number
	  */
	public static final int INVALID_BATCH_SIZE= 2055;
	
	/**
	  * Constant to indicate when batch size is not positive number
	  */
	public static final int INVALID_BATCH_SIZE_NOT_POSITIVE_NUMBER= 2056;
	
	/**
	 * Constant to indicate when batch already run
	 */
	public static final int BATCH_ALREADY_RUN = 2057;
	
	/**
	  * Constant to indicate when unable to process particular record in TBL_STAGING_INSTALL_BASE_WTY
	  */
	public static final int FAILED_RECORD_PROCESS_FLATTABLE_INSTALL_BASE_WTY = 2058;
	
	/**
	  * Constant to indicate when unable to close result set for TBL_STAGING_INSTALL_BASE_WTY
	  */
	public static final int FAILED_CLOSE_RESULTSET_FLATTABLE_INSTALL_BASE_WTY= 2059;
	
	/**
	  * Constant to indicate when unable to close statement object for TBL_STAGING_INSTALL_BASE_WTY
	  */
	public static final int FAILED_CLOSE_STATEMENT_FLATTABLE_INSTALL_BASE_WTY= 2060;
	
	/**
	  * Constant to indicate when error occurred during fetching total records to be processed from FLATTABLE_INSTALLBASE
	  */
	public static final int FAILED_FETCH_TOTAL_RECORDS= 2061;

	/**
	 * Constant to indicate when error occured during creating output folder
	 */
	public static final int FAILED_FOLDER_CREATION = 2062;
		
	/**
	  * Constant to indicate when unable to create sql statements for TBL_OPEN_SALES_ORDER_ERRORS 
	  */
	public static final int FAILED_CREATE_STMT_OSO_CONVERSION_ERRORS = 2063;
	
	/**
	  * Constant to indicate when unable to add sql statements to batch for TBL_OPEN_SALES_ORDER_ERRORS 
	  */
	public static final int FAILED_ADDING_BATCH_OSO_CONVERSION_ERRORS = 2064;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_OPEN_SALES_ORDER_ERRORS 
	  */
	public static final int FAILED_UPDATE_BATCH_OSO_CONVERSION_ERRORS = 2065;

	/**
	  * Constant to indicate when unable to create sql statements for TBL_INSTALLBASE_ERRORS 
	  */
	public static final int FAILED_CREATE_STMT_INSTALLBASE_CONVERSION_ERRORS = 2063;
	
	/**
	  * Constant to indicate when unable to add sql statements to batch for TBL_INSTALLBASE_ERRORS 
	  */
	public static final int FAILED_ADDING_BATCH_INSTALLBASE_CONVERSION_ERRORS = 2064;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_INSTALLBASE_ERRORS 
	  */
	public static final int FAILED_UPDATE_BATCH_INSTALLBASE_CONVERSION_ERRORS = 2065;
		
	/**
	  * Constant to indicate when unable to rename log file
	  */
	public static final int FAILED_RENAME_LOG_FILE= 2066;

	/**
	  * Constant to indicate when shipping method code is not valid
	  */
	public static final int INVALID_SHIPPING_METHOD_CODE_INSTALLBASE_CONVERSION = 2071;
	
	/**
	  * Constant to indicate when organization name can't be ocnverted to sterling store number
	  */
	public static final int INVALID_ORGANIZATION_NAME_INSTALLBASE_CONVERSION = 2072;
	
	/**
	  * Constant to indicate when pos transaction date is not as per format MM/dd/yyyy hh:mm:ss
	  */
	public static final int INVALID_POS_TRANS_DATE_INSTALLBASE_CONVERSION = 2073;		
	
	/**
	  * Constant to indicate when customer id length is more than 40
	  */
	public static final int INVALID_CUSTOMERID_INSTALLBASE_CONVERSION = 2079;
	
	/**
	  * Constant to indicate when mobile length is more than 40
	  */
	public static final int INVALID_MOBILE_INSTALLBASE_CONVERSION = 2080;
	
	/**
	  * Constant to indicate when day phone length is more than 40	
	  */
	public static final int INVALID_DAYPHONE_INSTALLBASE_CONVERSION = 2081;
	
	/**
	  * Constant to indicate when day fax length is more than 35
	  */
	public static final int INVALID_DAYFAX_INSTALLBASE_CONVERSION = 2082;
	
	/**
	  * Constant to indicate when eve phone length is more than 40
	  */
	public static final int INVALID_EVEPHONE_INSTALLBASE_CONVERSION = 2083;
	
	/**
	  * Constant to indicate when fulfillment store length is more than 40
	  */
	public static final int INVALID_FULFILLMENTSTORE_INSTALLBASE_CONVERSION = 2088;
	
	/**
	  * Constant to indicate when item id length is more than 40
	  */
	public static final int INVALID_ITEMID_INSTALLBASE_CONVERSION = 2090;
	
	/**
	  * Constant to indicate when xsd directory missing in input parameters
	  */
	public static final int MISSING_XSD_DIRECTORY= 2091;
	
	/**
	  * Constant to indicate when order number length is more than 40
	  */
	public static final int INVALID_ORDERNUMBER_INSTALLBASE_CONVERSION = 2094;
	
	/**
	  * Constant to indicate when pos register id length is more than 20
	  */
	public static final int INVALID_POSREGISTERID_INSTALLBASE_CONVERSION = 2095;
	
	/**
	  * Constant to indicate when pos transaction id type length is more than 40
	  */
	public static final int INVALID_POSTRANSID_INSTALLBASE_CONVERSION = 2096;
	
	/**
	  * Constant to indicate when quantity is missing
	  */
	public static final int MISIING_QUANTITY_INSTALLBASE_CONVERSION = 2097;
	
	/**
	  * Constant to indicate when quantity is not valid number
	  */
	public static final int INVALID_QUANTITY_INSTALLBASE_CONVERSION = 2098;

	/**
	  * Constant to indicate when quantity length is more than 14
	  */
	public static final int INVALID_QUANTITY_LENGTH_INSTALLBASE_CONVERSION = 2099;

	/**
	  * Constant to indicate when selling store length is more than 40
	  */
	public static final int INVALID_SELLINGSTORE_INSTALLBASE_CONVERSION = 3000;
	
	/**
	  * Constant to indicate when selling price is not valid number
	  */
	public static final int INVALID_SELLINGPRICE_INSTALLBASE_CONVERSION = 3001;
	
	/**
	  * Constant to indicate when selling price length is more than 19
	  */
	public static final int INVALID_SELLINGPRICE_LENGTH_INSTALLBASE_CONVERSION = 3002;

	/**
	  * Constant to indicate when warranty duration length is more than 40
	  */
	public static final int INVALID_WARRANTY_DURATION_INSTALLBASE_CONVERSION = 3003;
		
	/**
	  * Constant to indicate when customer id is missing
	  */
	public static final int MISSING_CUSTOMERID_INSTALLBASE_CONVERSION = 3005;

	/**
	  * Constant to indicate when item id is missing
	  */
	public static final int MISSING_ITEMID_INSTALLBASE_CONVERSION=3006;
	
	/**
	  * Constant to indicate when item type is missing
	  */
	public static final int MISSING_ITEMTYPE_INSTALLBASE_CONVERSION=3007;
	
	/**
	  * Constant to indicate when extended warranty start date is missing
	  */
	public static final int MISSING_EXT_WTYSTARTDATE_INSTALLBASE_CONVERSION=3008;
	
	/**
	  * Constant to indicate when extended warranty end date is missing
	  */
	public static final int MISSING_EXT_WTYENDDATE_INSTALLBASE_CONVERSION=3009;

	/**
	  * Constant to indicate when manufacture warranty start date is missing
	  */
	public static final int MISSING_MANU_WTYSTARTDATE_INSTALLBASE_CONVERSION=3010;
	
	/**
	  * Constant to indicate when manufacture warranty end date is missing
	  */
	public static final int MISSING_MANU_WTYENDDATE_INSTALLBASE_CONVERSION=3011;
	
	/**
	  * Constant to indicate when item type is not valid
	  */
	public static final int INVALID_ITEM_TYPE_INSTALLBASE_CONVERSION = 3012;
	
	/**
	  * Constant to indicate when exception occurs while getting connection to database
	  */
	public static final int INVALID_GET_CONNECTION = 3013;
	
	/**
	  * Constant to indicate when exception occurs while quantity of the instance_id is negative
	  */
	public static final int NEGATIVE_QUANTITY_FOR_INSTANCE_ID = 3014;
	
	/**
	  * Constant to indicate when No records populated to TBL_CLOSED_ORDERS_IN_13MONTHS with 13 months old orders
	  */
	public static final int NO_RECORD_POPULATION_TBL_CLOSED_ORDERS_IN_13MONTHS = 3101;
	
	/**
	  * Constant to indicate when unable to populate TBL_CLOSED_ORDERS_IN_13MONTHS with 13 months old orders
	  */
	public static final int FAILED_DATA_POPULATION_TBL_CLOSED_ORDERS_IN_13MONTHS = 3102;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_CLOSED_ORDERS_IN_13MONTHS
	  */
	public static final int FAILED_ANALYZE_TBL_CLOSED_ORDERS_IN_13MONTHS = 3103;	
	
	/**
	  * Constant to indicate when No records populated to TBL_CLOSED_ORDERS_BFR_13MONTHS with prior to 13 month old orders having valid warranty
	  */
	public static final int NO_RECORD_POPULATION_TBL_CLOSED_ORDERS_BFR_13MONTHS = 3104;
	
	/**
	  * Constant to indicate when unable to populate TBL_CLOSED_ORDERS_BFR_13MONTHS with prior to 13 month old orders having valid warranty
	  */
	public static final int FAILED_DATA_POPULATION_TBL_CLOSED_ORDERS_BFR_13MONTHS = 3105;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_CLOSED_ORDERS_BFR_13MONTHS
	  */
	public static final int FAILED_ANALYZE_TBL_CLOSED_ORDERS_BFR_13MONTHS = 3106;	
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_CLOSED_ORDER_LINES with 13 months old order lines
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_IN_13MONTHS = 3107;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_CLOSED_ORDER_LINES with 13 months old order lines
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_IN_13MONTHS = 3108;
	
	/**
	  * Constant to indicate when No records populated to TBL_STAGING_CLOSED_ORDER_LINES with prior to 13 months old order lines
	  */
	public static final int NO_RECORD_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_BFR_13MONTHS = 3109;
	
	/**
	  * Constant to indicate when unable to populate TBL_STAGING_CLOSED_ORDER_LINES with prior to 13 months old order lines
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_BFR_13MONTHS = 3110;
	
	/**
	  * Constant to indicate when error occurs analyzing TBL_STAGING_CLOSED_ORDER_LINES
	  */
	public static final int FAILED_ANALYZE_TBL_STAGING_CLOSED_ORDER_LINES = 3111;	
	
	/**
	  * Constant to indicate when error occurred during fetching total records to be processed from sequence CLOSED_SALES_SEQ
	  */
	public static final int FAILED_FETCH_TOTAL_CLOSED_ORDERS= 3115;
			
	/**
	  * Constant to indicate when fetch closed sales order data or not flag missing in input parameters
	  */
	public static final int MISSING_FETCH_CLOSED_SALES_ORDER_FLAG= 3121;
	
	/**
	  * Constant to indicate when invalid value for flag fetchClosedSalesOrderData passed
	  */
	public static final int INVALLID_VALUE_FOR_FETCHCLOSEDSALESORDERDATAONLY_FLAG= 3122;
	
	/**
	  * Constant to indicate when unable to create sql statements for TBL_STAGING_CLOSED_ORDER_LINES 
	  */
	public static final int FAILED_DATA_PROCESS_CLOSED_ORDERS = 3131;
	
	public static final int FAILED_DATA_PROCESS_OPEN_ORDERS = 4131;
	
	/**
	  * Constant to indicate when unable to close result set for TBL_STAGING_CLOSED_ORDER_LINES
	  */
	public static final int FAILED_CLOSE_RESULTSET_TBL_STAGING_CLOSED_ORDER_LINES = 3132;
	
	public static final int FAILED_CLOSE_RESULTSET_TBL_STAGING_OPEN_ORDER_LINES = 4132;
	
	/**
	  * Constant to indicate when unable to close statement object for TBL_STAGING_CLOSED_ORDER_LINES
	  */
	public static final int FAILED_CLOSE_STATEMENT_TBL_STAGING_CLOSED_ORDER_LINES= 3133;
	
	public static final int FAILED_CLOSE_STATEMENT_TBL_STAGING_OPEN_ORDER_LINES= 4133;
	
	/**
	  * Constant to indicate when unable to process particular record in TBL_STAGING_CLOSED_ORDER_LINES
	  */
	public static final int FAILED_RECORD_PROCESS_TBL_STAGING_CLOSED_ORDER_LINES = 3134;
	
	public static final int FAILED_RECORD_PROCESS_TBL_STAGING_OPEN_ORDER_LINES = 4134;
	
	/**
	  * Constant to indicate when error occurred during fetching records from XXCOFI.XXMCF_PRICE_ADJ_REASON_CODE
	  */
	public static final int FAILED_FETCH_CHARGE_NAMES= 3135;
	
	/**
	  * Constant to indicate when error occurred during fetching records from TBL_CLOSED_LINES_POS_PROVINCE
	  */
	public static final int FAILED_FETCH_POS_STORE_NUM= 3136;
	
	/**
	  * Constant to indicate when unable to create sql statements for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_CREATE_STMT_TBL_CLOSED_LINES_POS_PROVINCE = 3137;
	
	/**
	  * Constant to indicate when unable to add sql statements to batch for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_ADDING_BATCH_TBL_CLOSED_LINES_POS_PROVINCE = 3138;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_UPDATE_BATCH_TBL_CLOSED_LINES_POS_PROVINCE = 3139;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_UPDATE_TBL_CLOSED_LINES_POS_PROVINCE = 3140;
	
	/**
	  * Constant to indicate when error occurred during fetching records from TBL_CLOSED_LINES_POS_PROVINCE
	  */
	public static final int FAILED_FETCH_POS_STORE_NUMBER_PROVINCE_NAMES= 3141;
	
	/**
	  * Constant to indicate when unable to create sql statements for TBL_CLOSED_ORDER_STATISTICS 
	  */
	public static final int FAILED_CREATE_STMT_CLOSED_ORDER_CONVERSION_STATISTICS = 3142;
	
	public static final int FAILED_CREATE_STMT_OPEN_ORDER_CONVERSION_STATISTICS = 3151;
	
	/**
	  * Constant to indicate when unable to add sql statements to batch for TBL_CLOSED_ORDER_STATISTICS 
	  */
	public static final int FAILED_ADDING_BATCH_CLOSED_ORDER_CONVERSION_STATISTICS = 3143;
	
	public static final int FAILED_ADDING_BATCH_OPEN_ORDER_CONVERSION_STATISTICS = 3152;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_CLOSED_ORDER_STATISTICS 
	  */
	public static final int FAILED_UPDATE_BATCH_CLOSED_ORDER_CONVERSION_STATISTICS = 3144;
	
	public static final int FAILED_UPDATE_BATCH_OPEN_ORDER_CONVERSION_STATISTICS = 3153;
	
	/**
	  * Constant to indicate when unable to add sql statements to batch for TBL_CONVERTED_CLOSED_ORDERS 
	  */
	public static final int FAILED_ADDING_BATCH_CONVERTED_CLOSED_SALES_ORDERS= 3145;
	
	public static final int FAILED_ADDING_BATCH_CONVERTED_OPEN_SALES_ORDERS= 3154;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_CONVERTED_CLOSED_ORDERS 
	  */
	public static final int FAILED_UPDATE_BATCH_CONVERTED_CLOSED_SALES_ORDERS = 3146;
	
	public static final int FAILED_UPDATE_BATCH_CONVERTED_OPEN_SALES_ORDERS = 3155;
	
	/**
	  * Constant to indicate when unable to create sql statements for TBL_CONVERTED_CLOSED_ORDERS 
	  */
	public static final int FAILED_CREATE_STMT_CONVERTED_CLOSED_SALES_ORDERS = 3147;
	
	public static final int FAILED_CREATE_STMT_CONVERTED_OPEN_SALES_ORDERS = 3156;
	
	/**
	  * Constant to indicate when No records populated to TBL_STG_OPEN_ORDER_LINES
	  */
	public static final int NO_RECORD_POPULATION_TBL_STG_OPEN_ORDER_LINES = 2008;

	/**
	  * Constant to indicate when unable to populate TBL_STG_OPEN_ORDER_LINES
	  */
	public static final int FAILED_DATA_POPULATION_TBL_STG_OPEN_ORDER_LINES = 2009;

	/**
	  * Constant to indicate when fetch install base data or not flag missing in input parameters
	  */
	public static final int MISSING_FETCH_OSO_DATA_FLAG= 2054;
	
	/**
	  * Constant to indicate when invalid value for flag fetchInstallBaseData passed
	  */
	public static final int INVALLID_VALUE_FOR_FETCH_OSO_DATAONLY_FLAG= 2053;
	
	public static final int INVALID_JMS_PROVIDER_URL = 2101;
	
	public static final int INVALID_JMS_CONNECTION_QUEUE_FACTORY = 2102;
	
	public static final int INVALID_JMS_QUEUE_NAME_FOR_INSTALL_BASE = 2103;
	
	public static final int INVALID_JMS_QUEUE_NAME_FOR_CLOSED_SALES_ORDER = 2104;
	
	public static final int INVALID_JMS_QUEUE_NAME_FOR_OPEN_SALES_ORDER = 2105;
			
	/**
	  * Constant to indicate when unable to create sql statements for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_CREATE_STMT_TBL_OPEN_LINES_POS_PROVINCE = 3137;
	
	/**
	  * Constant to indicate when unable to add sql statements to batch for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_ADDING_BATCH_TBL_OPEN_LINES_POS_PROVINCE = 3138;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_UPDATE_BATCH_TBL_OPEN_LINES_POS_PROVINCE = 3139;
	
	/**
	  * Constant to indicate when unable to execute batch for TBL_CLOSED_LINES_POS_PROVINCE 
	  */
	public static final int FAILED_UPDATE_TBL_OPEN_LINES_POS_PROVINCE = 3140;
	
	/**
	  * Constant to indicate when error occurred during fetching records from TBL_CLOSED_LINES_POS_PROVINCE
	  */
	public static final int FAILED_FETCH_POS_STORE_NUMBER_PROVINCE_NAMES_OSO = 4141;
	
	public static final int FAILED_FETCH_POS_STORE_NUM_OSO = 4136;
	
	/**
	  * Constant to indicate when batch number missing in input parameters
	  */
	public static final int MISSING_BATCH_NUMBER= 3148;
	
	/**
	  * Constant to indicate when batch number is not a valid number
	  */
	public static final int INVALID_BATCH_NUMBER= 3149;
	
	/**
	  * Constant to indicate when batch number is not positive number
	  */
	public static final int INVALID_BATCH_NUMBER_NOT_POSITIVE_NUMBER= 3150;	

	/**
	  * Constant to indicate when conversion type missing in input parameters
	  */
	public static final int MISSING_CONVERSION_TYPE= 3151;
	
	/**
	 * Constant to indicate when batch directory doesn't exist
	 */
	public static final int BATCH_NOT_EXIST = 3152;
	
	/**
	  * Constant to indicate when jndi application context not created
	  */
	public static final int JNDI_CONTEXT_FAILED= 3153;
	
	/**
	  * Constant to indicate when jndi application context look up failed
	  */
	public static final int JNDI_LOOKUP_FAILED_QUEUE= 3154;	
	
	/**
	  * Constant to indicate when jndi application context look up failed for queue connection factory
	  */
	public static final int JNDI_LOOKUP_FAILED_QUEUE_CONNECTION_FACTORY= 3155;	
	
	/**
	  * Constant to indicate when exception occurs while creating queue connection 
	  */
	public static final int JMS_QUEUE_CONNECTION_ERROR= 3156;	
	
	/**
	  * Constant to indicate when exception occurs while creating queue session 
	  */
	public static final int JMS_QUEUE_SESSION_ERROR= 3157;	
	
	/**
	  * Constant to indicate when exception occurs while creating queue sender 
	  */
	public static final int JMS_QUEUE_SENDER_ERROR= 3158;
	
	/**
	  * Constant to indicate when exception occurs while sending queue message 
	  */
	public static final int JMS_QUEUE_MESSAGE_ERROR= 3159;
	
	/**
	  * Constant to indicate when exception occurs while commiting jms session 
	  */
	public static final int JMS_QUEUE_SESSION_COMMIT= 3160;
	
	/**
	  * Constant to indicate when io exception occurs while reading xml file
	  */
	public static final int FILE_READ_ERROR= 3161;
	
	/**
	  * Constant to indicate when exception occurs while pushing xml files from particular directory
	  */
	public static final int JMS_PUSH_FAIL_FOR_DIR= 3162;
	
	/**
	  * Constant to indicate when error occurred during updating TBL_JMS_QUEUE_STATISTICS
	  */
	public static final int FAILED_UPDATE_JMS_STATISTICS_INFO= 3163;
	
	/**
	  * Constant to indicate when No records populated to TBL_JMS_QUEUE_STATISTICS
	  */
	public static final int NO_RECORD_POPULATION_TBL_JMS_QUEUE_STATISTICS = 3164;
	
	

}

	
